______________________________________________

   2)  Choose "Contribution Range" from the Optimization menu.



   1)  Select the appropriate Adjustable cell.



To find the contribution range:

______________________________________________



or more will change the product mix.

negative infinity (-∞).  On the other hand, an increase to $1.52

per unit would not affect the optimal solution and is indicated by

produce "Italian Sausage".  Therefore, a decrease in the profit

is 0.00, Best Answer™ has determined that it doesn't pay to

"Italian Sausage" is -∞ to $1.51.  Since the value of the adjustable

In the same example, the contribution range for the adjustable



and you will want to re-optimize the model.

a value outside this range, the optimal solution will be affected

affect the optimal solution.  If the profit per unit later changes to

unit of "Summer Sausage" can fall between this range and not

indicates a range of $1.20 to $1.70.  This means that the profit per

model, the contribution range for the adjustable "Summer Sausage"

Consider the Product Mix example.   Once you have optimized the



dence you have in the optimal solution.

solution. This range allows you to estimate the degree of confi-

which the contribution may vary without affecting the optimal

The information is provided as a "Contribution Range", within



formula (e.g. profit per unit).  This amount is not always obvious.  

each ADJUSTABLE cell is contributing to the value of the objective

After OPTIMIZATION, Best Answer™ can display the amount